package com.app.mapper;

import com.app.model.BusinessModel;
import com.app.model.PlanBusinessModel;
import com.app.model.PlanFundsModel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface PlanBusinessMapper extends BaseMapper<PlanBusinessModel> {
    int selectPlanCount(PlanBusinessModel model);

    List<PlanBusinessModel> selectPlan(PlanBusinessModel model);

    List<PlanBusinessModel> selectPlanByTime(PlanBusinessModel model);

    List<PlanBusinessModel> select(int departmentId);

    void updatePlan(PlanBusinessModel model);
    @Insert("insert into lm_plan_business(department_id,task_plan,year) values(#{departmentId},#{taskPlan},#{year})")
    void insertPlan(Double taskPlan, String year, int departmentId);

    List<PlanBusinessModel> getBusinessTable(String year);

    List<PlanBusinessModel> getList();
}
